NTISthis.com

Evidence Guide: ICTPRG412 - Configure and maintain databases

Student: __________________________________________________

Signature: _________________________________________________

Tips for gathering evidence to demonstrate your skills

The important thing to remember when gathering evidence is that the more evidence the better - that is, the more evidence you gather to demonstrate your skills, the more confident an assessor can be that you have learned the skills not just at one point in time, but are continuing to apply and develop those skills (as opposed to just learning for the test!). Furthermore, one piece of evidence that you collect will not usualy demonstrate all the required criteria for a unit of competency, whereas multiple overlapping pieces of evidence will usually do the trick!

From the Wiki University

 

ICTPRG412 - Configure and maintain databases

What evidence can you provide to prove your understanding of each of the following citeria?

Determine the requirements of database administration

  1. Identify the components of a database instance
  2. Define and use tools to administer the database
Identify the components of a database instance

Completed
Date:

Teacher:		 Evidence:

 

 

 

 

 

 

 

Define and use tools to administer the database

Completed
Date:

Teacher:		 Evidence:

 

 

 

 

 

 

 

Install and configure the database system

  1. Verify the database software installation prerequisites
  2. Install the database software and related services
  3. Configure database instance, components and services
  4. Perform data management tasks
Verify the database software installation prerequisites

Completed
Date:

Teacher:		 Evidence:

 

 

 

 

 

 

 

Install the database software and related services

Completed
Date:

Teacher:		 Evidence:

 

 

 

 

 

 

 

Configure database instance, components and services

Completed
Date:

Teacher:		 Evidence:

 

 

 

 

 

 

 

Perform data management tasks

Completed
Date:

Teacher:		 Evidence:

 

 

 

 

 

 

 

Manage database security and integrity

  1. Create and administer users
  2. Create and manage the permissions to perform database operations
  3. Create and manage roles
Create and administer users

Completed
Date:

Teacher:		 Evidence:

 

 

 

 

 

 

 

Create and manage the permissions to perform database operations

Completed
Date:

Teacher:		 Evidence:

 

 

 

 

 

 

 

Create and manage roles

Completed
Date:

Teacher:		 Evidence:

 

 

 

 

 

 

 

Optimise and back up database

  1. Configure the database for backup and recovery operations
  2. Create and manage database backups
  3. Restore and perform database recovery
  4. Tune and perform database optimisation
Configure the database for backup and recovery operations

Completed
Date:

Teacher:		 Evidence:

 

 

 

 

 

 

 

Create and manage database backups

Completed
Date:

Teacher:		 Evidence:

 

 

 

 

 

 

 

Restore and perform database recovery

Completed
Date:

Teacher:		 Evidence:

 

 

 

 

 

 

 

Tune and perform database optimisation

Completed
Date:

Teacher:		 Evidence:

 

 

 

 

 

 

 

Document the database

  1. Document the maintenance and tuning work performed on the database
  2. Document the users added to system
Document the maintenance and tuning work performed on the database

Completed
Date:

Teacher:		 Evidence:

 

 

 

 

 

 

 

Document the users added to system

Completed
Date:

Teacher:		 Evidence:

 

 

 

 

 

 

 

Assessed

Teacher: ___________________________________ Date: _________

Signature: ________________________________________________

Comments:

 

 

 

 

 

 

 

 

Instructions to Assessors

Evidence Guide

ELEMENT

PERFORMANCE CRITERIA

Elements describe the essential outcomes.

Performance criteria describe the performance needed to demonstrate achievement of the element.

1. Determine the requirements of database administration

1.1 Identify the components of a database instance

1.2 Define and use tools to administer the database

2. Install and configure the database system

2.1 Verify the database software installation prerequisites

2.2 Install the database software and related services

2.3 Configure database instance, components and services

2.4 Perform data management tasks

3. Manage database security and integrity

3.1 Create and administer users

3.2 Create and manage the permissions to perform database operations

3.3 Create and manage roles

4. Optimise and back up database

4.1 Configure the database for backup and recovery operations

4.2 Create and manage database backups

4.3 Restore and perform database recovery

4.4 Tune and perform database optimisation

5. Document the database

5.1 Document the maintenance and tuning work performed on the database

5.2 Document the users added to system

Required Skills and Knowledge

ELEMENT

PERFORMANCE CRITERIA

Elements describe the essential outcomes.

Performance criteria describe the performance needed to demonstrate achievement of the element.

1. Determine the requirements of database administration

1.1 Identify the components of a database instance

1.2 Define and use tools to administer the database

2. Install and configure the database system

2.1 Verify the database software installation prerequisites

2.2 Install the database software and related services

2.3 Configure database instance, components and services

2.4 Perform data management tasks

3. Manage database security and integrity

3.1 Create and administer users

3.2 Create and manage the permissions to perform database operations

3.3 Create and manage roles

4. Optimise and back up database

4.1 Configure the database for backup and recovery operations

4.2 Create and manage database backups

4.3 Restore and perform database recovery

4.4 Tune and perform database optimisation

5. Document the database

5.1 Document the maintenance and tuning work performed on the database

5.2 Document the users added to system

Evidence of the ability to:

install and configure database software, according to requirements

manage database files, integrity, users and security

create backup and restore databases

monitor database performance

document the database work, and database users added.

Note: If a specific volume or frequency is not stated, then evidence must be provided at least once.

To complete the unit requirements safely and effectively, the individual must:

outline the principles of database design

summarise the features of desktop operating systems

explain the principles of relational databases

describe the functions of computer hardware and components

explain computer networking and components

explain uses of structured query language (SQL).